|
Symbolic Link (SYLK) is a Microsoft file format typically used to exchange data between applications, specifically spreadsheets. SYLK files conventionally have a .slk suffix. Composed of only displayable ANSI characters, it can be easily created and processed by other applications, such as databases.Microsoft does not publish a SYLK specification. Variants of the format are supported by Multiplan, Microsoft Excel, Microsoft Works, OpenOffice.org, and Gnumeric. Note that even if a SYLK file is created by an application that supports Unicode (for example Microsoft Excel), the SYLK file will be encoded in the current system's ANSI code page, not in Unicode. If the application contained characters that were displayable in Unicode but have no codepoint in the current system's code page, they will be converted to question marks ('?') in the SYLK file. Also note that if a character string in the SYLK file is to contain a semicolon (;) then it should be prefixed with another semicolon so the string would appear as e.g.; "WIDGET#04;;AXC1254". MS Excel will strip the first semicolon on import and the data element will appear as "WIDGET#04;AXC1254". It appears that the semicolon acts as an escape character of sorts. A commonly encountered (and spurious) 'occurrence' of the SYLK file happens when a Comma-separated Value format is saved with an unquoted first field name of 'ID', that is the first two characters match the first two characters of the SYLK file format. Microsoft Excel (at least to Office 2007) will then emit misleading error messages relating to the format of the file, such as "The file you are trying to open, 'x.csv', is in a different format than specified by the file extension...".〔(【引用サイトリンク】 title="SYLK: File format is not valid" error message when you open file )〕〔(【引用サイトリンク】 title=Excel CSV import returns an SYLK file format error )〕 ==Sample SYLK code== As an example, the following SYLK code in a text file with the .slk extension: ID;P C;Y1;X1;K"Row 1" C;Y2;X1;K"Row 2" C;Y3;X1;K"Total" C;Y1;X2;K11 C;Y2;X2;K22 C;Y3;X2;K0 E would be displayed like this when read by an appropriate spreadsheet: 抄文引用元・出典: フリー百科事典『 ウィキペディア（Wikipedia）』 ■ウィキペディアで「SYmbolic LinK (SYLK)」の詳細全文を読む スポンサード リンク
|